UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUhO2W7LW8IBkS9G8m6Id8O7lWzs8GRNq/XPDKtUMIA='
WHERE
key_id = 'c821e46c5b35212b67c1584d75c41584a297381b3cca550a707b49c9eb3cd88a'
AND (
token = 'HUhO2W7LW8IBkS9G8m6Id8O7lWzs8GRNq/XPDKtUMIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)