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