UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4pPQIw/ArweNk5KuQV6iteuRdjJw/NiUHszo4hR1jXo=' 
WHERE 
  key_id = '939738125a00d509841b4963059242327a83018262badf7ca7c2f40c75d7a3f1' 
  AND (
    token = '4pPQIw/ArweNk5KuQV6iteuRdjJw/NiUHszo4hR1jXo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034