UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vK9/PJ95DWauqRDCvbPc6uEW2RO8asKXE0/xrFtO5do='
WHERE
key_id = '0e6c90670d6c21b3ca70ac77debb57dd52e945577d7844dbc80b09bd5dc9ad86'
AND (
token = 'vK9/PJ95DWauqRDCvbPc6uEW2RO8asKXE0/xrFtO5do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)