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