UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SfYVn2Uus1sPR+EtPjqQ6cx4ZTjpN+5pdUgFfk+VPkw=' 
WHERE 
  key_id = 'e05c541dacc66eed8c0c32eb9d0cfbce02263beb3de5ec74f18c3e2f9b59e81f' 
  AND (
    token = 'SfYVn2Uus1sPR+EtPjqQ6cx4ZTjpN+5pdUgFfk+VPkw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021