UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7PlLbuECFw6cicPkun4IUaYkb7fX91gnIuscWFyXAJ0='
WHERE
key_id = 'aa805a3a729f146875b5ba4b96e0b540a4b104fdf7e2019c992d74d60809fb14'
AND (
token = '7PlLbuECFw6cicPkun4IUaYkb7fX91gnIuscWFyXAJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)