UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sz+TZGwn2TvuQd5c3P+Sw7xoDwiiHT2YytzubZv8YZo='
WHERE
key_id = '3b9dc0ae5a1661dbf0554a3f320297b96bbeb0d5e8b04b00a97cfd7a2b2ae1a5'
AND (
token = 'Sz+TZGwn2TvuQd5c3P+Sw7xoDwiiHT2YytzubZv8YZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)