UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qlxEl4XOG1hKuLU9Wyd7PzLG5aHa6k867FoEoidrVE='
WHERE
key_id = 'af8496ee3044b4e6e18bc3237cc8968794f3787692b11047f8f9404fd76fbda0'
AND (
token = '8qlxEl4XOG1hKuLU9Wyd7PzLG5aHa6k867FoEoidrVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)