UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9MDqjkcATJ4uBdNbG+s9BQV/kTcvza0YXUSBg/k6aU='
WHERE
key_id = 'ad1f638013af139448ec660ca2af3de4d173f98345492062e845dff3cf1f2114'
AND (
token = 'C9MDqjkcATJ4uBdNbG+s9BQV/kTcvza0YXUSBg/k6aU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)