UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ChJQOHkdn6LffKf8hTo8YZ9RA58PnNYrn2wk4PQWvyc='
WHERE
key_id = '44e47bacc406800adfa6e9dc44203b782a9bc6090513146ccf5fec2e9d730f2b'
AND (
token = 'ChJQOHkdn6LffKf8hTo8YZ9RA58PnNYrn2wk4PQWvyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)