UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4lHRwsKyRyltzER3x6bOLU1zk+TP8wL0OPaZfCmCdw='
WHERE
key_id = 'b12ad20219440579035454514f67ac041ccbc17a1bb14a9731519007e858d861'
AND (
token = 'H4lHRwsKyRyltzER3x6bOLU1zk+TP8wL0OPaZfCmCdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)