UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfe3ekFNGWFghjQpZAhYiwacSnWJTN5AMt3R2J7KruY='
WHERE
key_id = 'e704c7d3a4051cab35b48d2cb5e36790860498ad03ddf84a155ce780175da060'
AND (
token = 'dfe3ekFNGWFghjQpZAhYiwacSnWJTN5AMt3R2J7KruY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)