UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBOLMPX+UJ1m8wjVRg0w5VHfsTQkXI39nlJcuBpOTS8='
WHERE
key_id = '6e2bd7ec25c2630897ae865310459b098b2ce5310e9ea33aa93bb759476991c3'
AND (
token = 'HBOLMPX+UJ1m8wjVRg0w5VHfsTQkXI39nlJcuBpOTS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)