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