UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8J/3VJhWFJjUQZYRZH1jpXdzWw6hlrrEW4MpdLe5oKA=' 
WHERE 
  key_id = '189d568ce63b182e342f26ec09a59a8ce67e5410d5f70ffacc310bf65a2405cd' 
  AND (
    token = '8J/3VJhWFJjUQZYRZH1jpXdzWw6hlrrEW4MpdLe5oKA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048