UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'I9oLGtp47+3FPe0jqeJClrdhOtkK5LTfksHgaPfF7ks=' 
WHERE 
  key_id = 'd1dccddf41b952893313b2d2ec56fbd8757132d15e714633d90e1f06f151b7b5' 
  AND (
    token = 'I9oLGtp47+3FPe0jqeJClrdhOtkK5LTfksHgaPfF7ks=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043