UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C3m3yEgh4o5A+CDJzpxK6SI4AKBYrFdxDaLgZegWz/g=' 
WHERE 
  key_id = '238e148fceed5e647f721ade2baa8e577ec96c0ac5ef105257de9ee29da6e967' 
  AND (
    token = 'C3m3yEgh4o5A+CDJzpxK6SI4AKBYrFdxDaLgZegWz/g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047