UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/llGOKzZfCIRZh7heLynDkv4+osDUXPFHeDcSafrbz4=' 
WHERE 
  key_id = '596590858b5a36898c3344fd3340fd6895e13f64f9a0866b6138814305515a27' 
  AND (
    token = '/llGOKzZfCIRZh7heLynDkv4+osDUXPFHeDcSafrbz4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022