UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3rllZl8PGkXXGUKo8omo5OOnB3M/kPQsdrffXO+59xc=' 
WHERE 
  key_id = 'e2ce583d093588f2b1d17ed8e6981bffcd6847f5c8f25d7a69cebb64eb43833a' 
  AND (
    token = '3rllZl8PGkXXGUKo8omo5OOnB3M/kPQsdrffXO+59xc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00642