UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zr4/dYD2RSBLvS3MWBoW52n/V/sT2CPp3bBNLEy4do4='
WHERE
key_id = '8a81c8849ad893c6d996226e1ec2c2819037173da33e0b156a3cd20b384b6724'
AND (
token = 'zr4/dYD2RSBLvS3MWBoW52n/V/sT2CPp3bBNLEy4do4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)