UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nITHWfEG5Px34FVLBNYlLdD/zaxCJ4eiQlkPA6va8G4='
WHERE
key_id = 'c7d70d2a5b76f08debab47e0ed89cef522690414bb2fbedfe5759f5cb0962748'
AND (
token = 'nITHWfEG5Px34FVLBNYlLdD/zaxCJ4eiQlkPA6va8G4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)