UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7w4zZC23kVCNyS5K0Bmlfqix3cVf6O6AkieYoq90tk='
WHERE
key_id = '4ac3babf190734c35a35a8465a4f41087eb18f8dcdcaa616d2c7b8751ca45afc'
AND (
token = 'r7w4zZC23kVCNyS5K0Bmlfqix3cVf6O6AkieYoq90tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)