UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7R+fVc7bJGjrMCx0YP3+bkJ4SnBj9dcmS3lJb2PVEp0='
WHERE
key_id = 'c65834ef7219f7a3cbe1d5f3fff408344f347ff0bbb223cf842cfb85774318b8'
AND (
token = '7R+fVc7bJGjrMCx0YP3+bkJ4SnBj9dcmS3lJb2PVEp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)