UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MciEYc3jRqzAjd5ik5sg5jnO9Qa8lDcg4A8uMPSxyRo='
WHERE
key_id = '9f97580b1ecd94fad50ebdfcdd0378ef92c63a60f42876107adc445fb5de6a72'
AND (
token = 'MciEYc3jRqzAjd5ik5sg5jnO9Qa8lDcg4A8uMPSxyRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)