UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsVnZNdZEIwwuOB8Ws53tDXkL+gkEEidCra0eOobosw='
WHERE
key_id = 'a00cd0ab0ffcc6d14f27e2b5b90611bced55d10f4a11ce53b776dc9c0ff67b27'
AND (
token = 'QsVnZNdZEIwwuOB8Ws53tDXkL+gkEEidCra0eOobosw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)