UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pssc6Y6NTzkE5zi0WBuLQ7F818dOksABZgySfVxMzkw='
WHERE
key_id = '855f0443b9a3ac3ace18e7e6459665e0abdca57f061158a7ba94c6659b1b1ae1'
AND (
token = 'Pssc6Y6NTzkE5zi0WBuLQ7F818dOksABZgySfVxMzkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)