UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AV0YfH3grvT2VDayqaM9OUatyGeJUe98cMXRaD64dUk='
WHERE
key_id = '20b6060f7e0e6f422d480bfb57338bc758025685e0d482804a1f0edaa798239d'
AND (
token = 'AV0YfH3grvT2VDayqaM9OUatyGeJUe98cMXRaD64dUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)