UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OB9P424wQnmf9KWGxYNOto2j5cVCwSkqva1ga3Ean8g='
WHERE
key_id = 'e547b69219328204397094a2929d11b8facec7ad6868e8e487868a95b153783c'
AND (
token = 'OB9P424wQnmf9KWGxYNOto2j5cVCwSkqva1ga3Ean8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)