UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TdQb+SX9vO71196iVwUTiblcYQwtG70kivhSACS5mZw='
WHERE
key_id = 'e07c41052b0c0982e8489bb0a35b3df9e6ce802a760effe7c9ee2920eab9fdd5'
AND (
token = 'TdQb+SX9vO71196iVwUTiblcYQwtG70kivhSACS5mZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)