UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdlifMzJOlu1qfyWUPGGa2RfZyA4G9ZYx5cce+OfvjM='
WHERE
key_id = '7ae42f93071830277bd885ec9b6efe1dae42944c98fea07da6d03982d5bdea7a'
AND (
token = 'XdlifMzJOlu1qfyWUPGGa2RfZyA4G9ZYx5cce+OfvjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)