UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TOlE/q8EHUTeNzatJUxvSQHoYAKZll0neq/2VvUlxxk=' 
WHERE 
  key_id = '46a1798f6fd23277e96864a0a6f21b122004a8a0c8c55eed8491615a0c2a4ea5' 
  AND (
    token = 'TOlE/q8EHUTeNzatJUxvSQHoYAKZll0neq/2VvUlxxk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034