UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGs4yA8+/U98OfQTotikFq8TnJQcBgnx7EMcCmyzjHw='
WHERE
key_id = 'a3eb89aafe3af1c0a58b9e9744b133c748c0b19ef9fd484bc9fe97f7ae7126bc'
AND (
token = 'bGs4yA8+/U98OfQTotikFq8TnJQcBgnx7EMcCmyzjHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)