UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+hQgJhB6ZkKLVHS3KiA3WY9hDKXN88C/H/jnlY4bCfU='
WHERE
key_id = '3da9397d5ae1682423fc19edba80d8dc71ff7086441e3f5c97067e0a92b17582'
AND (
token = '+hQgJhB6ZkKLVHS3KiA3WY9hDKXN88C/H/jnlY4bCfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)