UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4KCbRkr5i6IS1nI8QDVsG7Sr6GSc/xBhWIPBc1Xjicc=' 
WHERE 
  key_id = '3869ee33d2bee01c155deb12c51b4e732acd02465b2b08029b5b1cbe404aa04e' 
  AND (
    token = '4KCbRkr5i6IS1nI8QDVsG7Sr6GSc/xBhWIPBc1Xjicc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038