UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8OoKQNn28t6p5U5lxvVu1CCa5igHYWAKcz1kbFvIyGc=' 
WHERE 
  key_id = '66fee49e7a7e206a69518543d4b4debf4adb1c0ceb734a6fbf4ad2e2af981ff3' 
  AND (
    token = '8OoKQNn28t6p5U5lxvVu1CCa5igHYWAKcz1kbFvIyGc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045