UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SwA1zlKV1A13GmdrwqQEQBig6Au2rUd9IARByhBa/do='
WHERE
key_id = '7b71affdbb2e6e2aaf815eb831f485b9108b8dd17cd251ed35dad1e312d8947b'
AND (
token = 'SwA1zlKV1A13GmdrwqQEQBig6Au2rUd9IARByhBa/do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)