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