UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+KTw0TbLF30EmCQ5cmgZWaWDVjCaBWjZOSExAFAmow='
WHERE
key_id = '77a20f91b5e9f44a9186988030217f6fe099e810f3489624e40bea8b46b00b71'
AND (
token = 'X+KTw0TbLF30EmCQ5cmgZWaWDVjCaBWjZOSExAFAmow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)