UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p/ugk506TF+s8eaNvs2RvgA+zrfSqFZi2huS0E2vIXc='
WHERE
key_id = 'd6604dcee39cc69b44b261e47dca30bc95996e9d0c19604823c301811d6d15b7'
AND (
token = 'p/ugk506TF+s8eaNvs2RvgA+zrfSqFZi2huS0E2vIXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)