UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'An8SOXRwBiz1XrRdUFgsyFXcTVYIhUWX9O/Hg/eTIaE=' 
WHERE 
  key_id = 'd236dd1e3e76a2d368e831f6f29367713209f96a530adbdfc41c18fc21e16447' 
  AND (
    token = 'An8SOXRwBiz1XrRdUFgsyFXcTVYIhUWX9O/Hg/eTIaE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027